package cn.gson.boot.model.mapper;

import cn.gson.boot.model.pojos.Kehu;
import cn.gson.boot.model.pojos.UserMainPage;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MainPageMapper {

    public List<Kehu> selectKehu();

    //查询员工七天内新增的客户
    public Integer selectEmpSevenDayKehu(@Param("kcjTime") String kcjTime,
                                            @Param("empId") Integer empId);
    //查询员工七天内新增的订单(统计)
    public Integer selectEmpSevenDayDingDan(@Param("ddTime") String ddTime,
                                         @Param("empName") String empName);

    //查询七天内新增的合同(统计)
    public Integer selectSevenDayHeTong(@Param("htTime") String htTime);
    //查询七天内新增的订单(统计)
    public Integer selectSevenDayDingDan(@Param("ddTime") String ddTime);
    //查询七天内新增的回款(统计)
    public Integer selectSevenDayHuiKuan(@Param("hkTime") String hkTime);
    //查询七天内新增的退货(统计)
    public Integer selectSevenDayTuiHuo(@Param("thTime") String thTime);
    //查询七天内新增的换货(统计)
    public Integer selectSevenDayHuanHuo(@Param("hhTime") String hhTime);

    //查询员工负责的首所有客户
    public Integer selectEmpKehu(String empName);
    //查询员工负责的所有合同
    public Integer selectEmpHetong(String empName);
    //查询员工负责的所有订单
    public Integer selectEmpDingDan(String empName);


    //查询所有的员工的姓名
    public List<String> selectAllEmpNameQvChong();
    public Integer selectPaiHang(@Param("time") String time,
                                      @Param("empName") String empName);

    //按时间查合同
    public Integer selectHeTongByTime(String time);
    //按时间查订单
    public Integer selectDingDanByTime(String time);
    //按时间查客户
    public Integer selectKeHuByTime(String time);
}
